Aspire System Interview Questions

1.How ur getting requests 
2.If u need any clarification in task who is the contact person
4. What r the things u ll do once task completed  
5.Aggregate functions
6.Listagg with Concate query
7.Mview
8.Can u able to create Index for columns which is having null values? Will Optimizer  read that index?
9.Hints
10.Merge
11.All loading concepts(sql loader detailed) 
12.Procedure using truncate
13.Procedure detailed 
14.Functions detailed 
15.Explain plan
16.About performance tuning 
17.Bulk collect & bulk bind
18. Save exception
19. Few Unix commands
20. Use of anonymous block
21.Cursor
22.Collection